from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()


class StockAccountMetric(Base):
    __tablename__ = 'stock_account_metric'
    id = Column(Integer, primary_key=True, autoincrement=True)
    code = Column(String(10))
    date = Column(String(10))
    tbmg = Column(String(20))
    jqmg = Column(String(20))
    mgsy = Column(String(20))
    kfmg = Column(String(20))
    mgjz = Column(String(20))
    mgjzad = Column(String(20))
    mgjy = Column(String(20))
    mggjj = Column(String(20))
    mgwly = Column(String(20))
    zclr = Column(String(10))
    zylr = Column(String(10))
    zzlr = Column(String(10))
    cblr = Column(String(10))
    yylr = Column(String(10))
    zycb = Column(String(10))
    xsjl = Column(String(10))
    gbbc = Column(String(10))
    jzbc = Column(String(10))
    zcbc = Column(String(10))
    xsml = Column(String(10))
    xxbz = Column(String(10))
    fzy = Column(String(10))
    zybz = Column(String(10))
    gxff = Column(String(10))
    tzsy = Column(String(10))
    zyyw = Column(String(20))
    jzsy = Column(String(10))
    jqjz = Column(String(10))
    kflr = Column(String(20))
    zysr = Column(String(10))
    jlzz = Column(String(10))
    jzzz = Column(String(10))
    zzzz = Column(String(10))
    yszz = Column(String(10))
    yszzt = Column(String(10))
    chzz = Column(String(10))
    chzzl = Column(String(10))
    gzzz = Column(String(10))
    zzzzl = Column(String(10))
    zzzzt = Column(String(10))
    ldzz = Column(String(10))
    ldzzt = Column(String(10))
    gdzz = Column(String(10))
    ldbl = Column(String(10))
    sdbl = Column(String(10))
    xjbl = Column(String(10))
    lxzf = Column(String(10))
    zjbl = Column(String(10))
    gdqy = Column(String(10))
    cqfz = Column(String(10))
    gdgd = Column(String(10))
    fzqy = Column(String(10))
    zczjbl = Column(String(10))
    zblv = Column(String(10))
    gdzcjz = Column(String(10))
    zbgdh = Column(String(10))
    cqbl = Column(String(10))
    qxjzb = Column(String(10))
    gdzcbz = Column(String(10))
    zzc = Column(String(20))
    jyxj = Column(String(10))
    zcjyxj = Column(String(10))
    jylrb = Column(String(10))
    jyfzl = Column(String(10))
    xjlbl = Column(String(10))
    dqgptz = Column(String(20))
    dqzctz = Column(String(20))
    dqjytz = Column(String(20))
    qcgptz = Column(String(20))
    cqzqtz = Column(String(20))
    cqjyxtz = Column(String(20))
    yszk1 = Column(String(20))
    yszk12 = Column(String(20))
    yszk23 = Column(String(20))
    yszk3 = Column(String(20))
    yfhk1 = Column(String(20))
    yfhk12 = Column(String(20))
    yfhk23 = Column(String(20))
    yfhk3 = Column(String(20))
    ysk1 = Column(String(20))
    ysk12 = Column(String(20))
    ysk23 = Column(String(20))
    ysk3 = Column(String(20))

    def __init__(self, code, date, tbmg, jqmg, mgsy, kfmg, mgjz, mgjzad, mgjy, mggjj, mgwly, zclr, zylr, zzlr,
                 cblr, yylr, zycb, xsjl, gbbc, jzbc, zcbc, xsml, xxbz, fzy, zybz, gxff, tzsy, zyyw, jzsy, jqjz, kflr,
                 zysr, jlzz, jzzz, zzzz, yszz, yszzt, chzz, chzzl, gzzz, zzzzl, zzzzt, ldzz, ldzzt, gdzz, ldbl, sdbl,
                 xjbl, lxzf, zjbl, gdqy, cqfz, gdgd, fzqy, zczjbl, zblv, gdzcjz, zbgdh, cqbl, qxjzb, gdzcbz, zzc,
                 jyxj, zcjyxj, jylrb, jyfzl, xjlbl, dqgptz, dqzctz, dqjytz, qcgptz, cqzqtz, cqjyxtz, yszk1, yszk12,
                 yszk23, yszk3, yfhk1, yfhk12, yfhk23, yfhk3, ysk1, ysk12, ysk23, ysk3):
        self.code = code
        self.date = date
        self.tbmg = tbmg
        self.jqmg = jqmg
        self.mgsy = mgsy
        self.kfmg = kfmg
        self.mgjz = mgjz
        self.mgjzad = mgjzad
        self.mgjy = mgjy
        self.mggjj = mggjj
        self.mgwly = mgwly
        self.zclr = zclr
        self.zylr = zylr
        self.zzlr = zzlr
        self.cblr = cblr
        self.yylr = yylr
        self.zycb = zycb
        self.xsjl = xsjl
        self.gbbc = gbbc
        self.jzbc = jzbc
        self.zcbc = zcbc
        self.xsml = xsml
        self.xxbz = xxbz
        self.fzy = fzy
        self.zybz = zybz
        self.gxff = gxff
        self.tzsy = tzsy
        self.zyyw = zyyw
        self.jzsy = jzsy
        self.jqjz = jqjz
        self.kflr = kflr
